A Fast Method for Ensuring the Consistence of Integrity Constraints
نویسندگان
چکیده
The last few years have seen an increasing trend to use database technology in more innovative and diverse application domains which places even greater demands on DBMS for accuracy of information. The provision of correct and reliable data is therefore of vital importance and systems for integrity enforcement crucial. At the same time, as systems become more sophisticated, the sheer number and complexity of integrity constraints, associated with applications, is steadily increasing together with the rate at which changes are made to the constraint base itself. In this paper we examine the problem of constraint maintenance and propose a fast method for validating additional and modified constraints. The method is based on the construction of Modal Records to determine if a newly defined constraint is consistent with an existing constraint set.
منابع مشابه
مسیریابی حرکت روباتهای ماشینواره با روش پیشروی سریع
The Robot Motion Planning (RMP) problem deals with finding a collision-free start-to-goal path for a robot navigating among workspace obstacles. Such a problem is also encountered in path planning of intelligent vehicles and Automatic Guided Vehicles (AGVs). In terms of kinematic constraints, the RMP problem can be categorized into two groups of Holonomic and Nonholonomic problems. In the first...
متن کاملUnit commitment by a fast and new analytical non-iterative method using IPPD table and “λ-logic” algorithm
Many different methods have been presented to solve unit commitment (UC) problem in literature with different advantages and disadvantages. The need for multiple runs, huge computational burden and time, and poor convergence are some of the disadvantages, where are especially considerable in large scale systems. In this paper, a new analytical and non-iterative method is presented to solve UC p...
متن کاملGuard Independence and Constraint-Preserving Snapshot Isolation
A method for detecting potential violations of integrity constraints of concurrent transactions running under snapshot isolation (SI) is presented. In contrast to methods for ensuring full serializability under snapshot isolation, violations of integrity constraints may be detected by examining certain read-write interaction of only two transactions at a time. The method, called constraint-pres...
متن کاملLinear plus fractional multiobjective programming problem with homogeneous constraints using fuzzy approach
We develop an algorithm for the solution of multiobjective linear plus fractional programming problem (MOL+FPP) when some of the constraints are homogeneous in nature. Using homogeneous constraints, first we construct a transformation matrix T which transforms the given problem into another MOL+FPP with fewer constraints. Then, a relationship between these two problems, ensuring that the solu...
متن کاملEnsuring HIV Data Availability, Transparency and Integrity in the MENA Region; Comment on “Improving the Quality and Quantity of HIV Data in the Middle East and North Africa: Key Challenges and Ways Forward”
In this commentary, we elaborate on the main points that Karamouzian and colleagues have made about HIV data scarcity in Middle Eastern and North African (MENA) countries. Without accessible and reliable data, no epidemic can be managed effectively or efficiently. Clearly, increased investments are needed to bolster capabilities to capture and interpret HIV surveillance data. We believe that th...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1999